SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddApplyingRecord]
	
	(
	@param_applicant_type NVARCHAR(50),
	@param_applicant_userID NVARCHAR(50),
	@param_recruit_position INT,
	@param_resume_path NVARCHAR(100),
	@param_add_time SMALLDATETIME,
	@param_user_add NVARCHAR(50),
	@param_applicant_message TEXT 
	)
	
AS
	/* SET NOCOUNT ON */
	INSERT INTO dbo.JOL_Recruitment_ApplyingRecords
	        ( applicant_type ,
	          applicant_userID ,
	          recruit_position ,
	          resume_path ,
	          add_time ,
	          user_add ,
	          last_stage ,
	          result ,
	          applicant_message
	        )
	VALUES  ( @param_applicant_type , -- applicant_type - nvarchar(50)
	          @param_applicant_userID , -- applicant_userID - nvarchar(50)
	          @param_recruit_position, -- recruit_position - int
	          @param_resume_path , -- resume_path - nvarchar(100)
	          @param_add_time, -- add_time - smalldatetime
	          @param_user_add , -- user_add - nvarchar(50)
	          0 , -- last_stage - int
	         '未处理' , -- result - nvarchar(50)
	          @param_applicant_message  -- applicant_message - text
	        )
	
	RETURN
GO
